package com.css.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.css.entity.DataAirPortNum;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Dbj
 * @date 2024年11月07日  20:36
 */
@DS("slave")
@Mapper
public interface DataAirPortNumMapper extends BaseMapper<DataAirPortNum> {

    @Select("select  count(*) num from data_airport where ST_Intersects(geom, st_geomfromtext(#{geom},4490))")
    List<DataAirPortNum> getData(@Param("geom") String geom);
}
